﻿
GO
IF NOT EXISTS (SELECT RoleName FROM Roles WHERE RoleName = 'CCC' AND ApplicationId = 1)
BEGIN
INSERT INTO Roles(RoleName,ApplicationId)
     VALUES('CCC',1)
END


GO
IF NOT EXISTS (SELECT RoleName FROM Roles WHERE RoleName = 'Sales' AND ApplicationId = 1)
BEGIN
INSERT INTO Roles(RoleName,ApplicationId)
     VALUES('Sales',1)
END

GO
IF NOT EXISTS (SELECT RoleName FROM Roles WHERE RoleName = 'Support' AND ApplicationId = 1)
BEGIN
INSERT INTO Roles(RoleName,ApplicationId)
     VALUES('Support',1)
END

